﻿using ERP_RORZE_DLL.Product.Base;
using System;using ERP_RORZE_SYSTEM;
using System.Collections.Generic;
using System.Data;using ERP_RORZE_SYSTEM;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace ERP_RORZE_DLL.Product.DAO
{
    public class ClsWTSDAO : ExecuteSQL
    {
        ExecuteSQL Execute = new ExecuteSQL();
        public DataTable GetAllMachineWTSDetail()
        {
            string sql = clsConstantsFuction.ClsFuctionMachineWTS.GetAll;
            return Execute.DoStoreProcedure(sql, true);
        }

        public DataTable GetAllMachine()
        {
            string sql = clsConstantsFuction.ClsFuctionMachine.GetAllMachine;
            return Execute.DoStoreProcedure(sql, true);
        }
        public DataTable GetAllStaff()
        {
            string sql = clsConstantsFuction.ClsFuctionStaff.GetAll;
            return Execute.DoStoreProcedure(sql, true);
        }
        public DataTable GetAllMONo()
        {
            string sql = clsConstantsFuction.ClsFuctionMO.GetAllMOWTS;
            return Execute.DoStoreProcedure(sql, true);
        }
        public DataTable GetAllOptionID()
        {
            string sql = clsConstantsFuction.ClsFuctionOption.GetAll;
            return Execute.DoStoreProcedure(sql, true);
        }
        public DataTable GetAllWork()
        {
            string sql = clsConstantsFuction.ClsFuctionWork.GetAll;
            return Execute.DoStoreProcedure(sql, true);
        }
    }
}
